SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].ClientesCatUpdateCommand
(
	@ID numeric(10, 0),
	@CATEGORIA varchar(50),
	@Original_ID numeric(10, 0),
	@Original_CATEGORIA varchar(50)
)
AS
	SET NOCOUNT OFF;
UPDATE [CLIENTES_CAT] SET [ID] = @ID, [CATEGORIA] = @CATEGORIA WHERE (([ID] = @Original_ID) AND ([CATEGORIA] = @Original_CATEGORIA));
	
SELECT ID, CATEGORIA FROM CLIENTES_CAT WHERE (ID = @ID)
GO
